﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Search.aspx.cs" Inherits="Suanhua_Search" %>

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <p>
        井号：<asp:TextBox ID="TextBox1" runat="server" Height="19px" Width="120px"></asp:TextBox>
        <asp:Label ID="Label5" runat="server" Text="格式示例：8L110-98"></asp:Label>
    </p>
    <p>
        开工日期：从<asp:TextBox ID="TextBox2" runat="server" Height="19px" Width="120px"></asp:TextBox>
        到<asp:CalendarExtender ID="TextBox2_CalendarExtender" runat="server" 
            Animated="False" TargetControlID="TextBox2">
    </asp:CalendarExtender>
        <asp:TextBox ID="TextBox3" runat="server" Height="19px" Width="120px"></asp:TextBox>
        <asp:CalendarExtender ID="TextBox3_CalendarExtender" runat="server" 
            Enabled="True" TargetControlID="TextBox3">
        </asp:CalendarExtender>
        <asp:Label ID="Label6" runat="server" Text="格式示例：2012-6-1"></asp:Label>
        </p>
        <asp:Button ID="Button1" runat="server" onclick="Button1_Click" 
            Text="查询" Height="21px" Width="60px" />
    <asp:Button ID="Button2" runat="server" Height="21px" Text="导出" Width="60px" 
        onclick="Button2_Click" />
    <p>
        <asp:GridView ID="GridView1" runat="server" 
            AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" 
            GridLines="None" Width="900px">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="JH" HeaderText="井号" SortExpression="JH" />
                <asp:BoundField DataField="KGRQ" DataFormatString="{0:d}" HeaderText="开工日期" 
                    SortExpression="KGRQ" />
                <asp:BoundField DataField="WGRQ" DataFormatString="{0:d}" HeaderText="完工日期" 
                    SortExpression="WGRQ" />
                <asp:BoundField DataField="CSMC" HeaderText="措施名称" SortExpression="CSMC" />
                <asp:BoundField DataField="SGFS" HeaderText="施工方式" SortExpression="SGFS" />
                <asp:BoundField DataField="CSCD" HeaderText="措施层段" SortExpression="CSCD" />
                <asp:BoundField DataField="SHBJ" HeaderText="酸化半径" SortExpression="SHBJ" />
                <asp:BoundField DataField="BZ" HeaderText="备注" SortExpression="BZ" />
            </Columns>
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F5F7FB" />
            <SortedAscendingHeaderStyle BackColor="#6D95E1" />
            <SortedDescendingCellStyle BackColor="#E9EBEF" />
            <SortedDescendingHeaderStyle BackColor="#4870BE" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionStringForOracle %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionStringForOracle.ProviderName %>" 
            
            SelectCommand="SELECT &quot;JH&quot;, &quot;KGRQ&quot;, &quot;WGRQ&quot;, &quot;CSMC&quot;, &quot;SGFS&quot;, &quot;CSCD&quot;, &quot;SHBJ&quot;, &quot;BZ&quot; FROM &quot;BC_CSCGJL&quot; WHERE ((&quot;JH&quot; = :JH) AND (&quot;CSLB&quot; = :CSLB) AND (&quot;KGRQ&quot; &gt;= :KGRQ) AND (&quot;KGRQ&quot; &lt;= :KGRQ2))">
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox1" Name="JH" PropertyName="Text" 
                    Type="String" />
                <asp:Parameter DefaultValue="1200" Name="CSLB" Type="String" />
                <asp:ControlParameter ControlID="TextBox2" Name="KGRQ" PropertyName="Text" 
                    Type="DateTime" />
                <asp:ControlParameter ControlID="TextBox3" Name="KGRQ2" PropertyName="Text" 
                    Type="DateTime" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionStringForOracle %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionStringForOracle.ProviderName %>" 
            
            
            
            SelectCommand="SELECT &quot;JH&quot;, &quot;KGRQ&quot;, &quot;WGRQ&quot;, &quot;CSMC&quot;, &quot;SGFS&quot;, &quot;CSCD&quot;, &quot;SHBJ&quot;, &quot;BZ&quot; FROM &quot;BC_CSCGJL&quot; WHERE ((&quot;JH&quot; = :JH) AND (&quot;CSLB&quot; = :CSLB))">
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox1" Name="JH" PropertyName="Text" 
                    Type="String" />
                <asp:Parameter DefaultValue="1200" Name="CSLB" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionStringForOracle %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionStringForOracle.ProviderName %>" 
            
            SelectCommand="SELECT &quot;JH&quot;, &quot;KGRQ&quot;, &quot;WGRQ&quot;, &quot;CSMC&quot;, &quot;SGFS&quot;, &quot;CSCD&quot;, &quot;SHBJ&quot;, &quot;BZ&quot; FROM &quot;BC_CSCGJL&quot; WHERE ((&quot;CSLB&quot; = :CSLB) AND (&quot;KGRQ&quot; &gt;= :KGRQ) AND (&quot;KGRQ&quot; &lt;= :KGRQ2))">
            <SelectParameters>
                <asp:Parameter DefaultValue="1200" Name="CSLB" Type="String" />
                <asp:ControlParameter ControlID="TextBox2" Name="KGRQ" PropertyName="Text" 
                    Type="DateTime" />
                <asp:ControlParameter ControlID="TextBox3" Name="KGRQ2" PropertyName="Text" 
                    Type="DateTime" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:ScriptManager ID="ScriptManager1" runat="server" 
            EnableScriptGlobalization="True">
        </asp:ScriptManager>
    </p>
</asp:Content>

